#!/bin/sh

for i in `cat /var/www/traffic/test/in_port |awk '{print $1}'`
do
	mysql -uroot -p123456 -B traffic -e "select round(in_bits/1024/1024,2) as Trafficin from core_trafficlog where port_id=${i} and  date >='2020/12/24' and date < '2020/12/25' GROUP BY Trafficin desc limit 1">${i}_port
done
